package com.sinodata.bsm.cicp.collector.mysql;

public class MySQLContants {
    public MySQLContants() {
    }

    // 指标
    public static final String NA = "N/A";
    static final String TOTAL_USERS = " SHOW STATUS LIKE 'THREADS_CONNECTED' ";
    static final String ACTIVE_USERS = " SHOW STATUS LIKE 'THREADS_RUNNING' ";
    static final String SERVER_SQL = "SHOW STATUS LIKE ''";
    static final String SERVER_DATA_SEND_RATE = "SHOW STATUS LIKE ''";
    static final String SERVER_DATA_RECEIVE_RATE = "SHOW STATUS LIKE ''";
    static final String SERVER_ROWS_SORT = "SHOW STATUS LIKE 'SORT_ROWS'";
    static final String SERVER_QUERY_QUERIES = "SHOW STATUS LIKE 'QCACHE_QUERY_IN_CACHE'";
    static final String SERVER_QUERY_CACHE_FREE = "SHOW STATUS LIKE 'QCACHE_FREE_MEMORY'";
    static final String SERVER_QC_HIT_RATE = "SHOW STATUS LIKE ''";
    static final String SERVER_QCACHE_HITS = "SHOW STATUS LIKE 'QCACHE_HITS'";
    static final String SERVER_QCACHE_INSERTS = "SHOW STATUS LIKE 'QCACHE_INSERTS'";
    static final String SERVER_QCACHE_NOT_CACHED = " SHOW STATUS LIKE 'QCACHE_NOT_CACHED' ";
    static final String SERVER_COM_SELECT = "SHOW STATUS LIKE 'COM_SELECT'";
    static final String SERVER_THREAD_POOL = "SHOW STATUS LIKE 'THREADS_RUNNING'";
    static final String SERVER_KEY_EFFICIENCY = "SHOW STATUS LIKE ''";
    static final String SERVER_KEY_READS = "SHOW STATUS LIKE 'KEY_READS'";
    static final String SERVER_KEY_READS_REQUESTS = "SHOW STATUS LIKE 'KEY_READS_REQUESTS'";
    static final String INNODB_LOGICAL_WRITES = " SHOW INNODB STATUS ";
    static final String INNODB_LOGICAL_READ_RATE = " SHOW INNODB STATUS ";
    static final String INNODB_LOG_BUFFER_WRITES = " SHOW INNODB STATUS ";
    static final String INNODB_BUFFER_POOL_TREE = " SHOW STATUS LIKE '' ";
    static final String INNODB_BUFFER_POOL_HIT_RATE = " SHOW INNODB STATUS ";
    static final String INNODB_BUFFER_POOL_ROWS_PROCESSED = "SHOW STATUS LIKE ''";
    static final String INNODB_ROWS = "SHOW STATUS LIKE 'INNODB_ROWS_%'";
    static final String INNODB_PHYSICAL_WRITES = "SHOW INNODB STATUS ";
    static final String INNODB_PHYSICAL_READ_RATE = "SHOW INNODB STATUS ";
    static final String INNODB_LOG_FILE_WRITES_RATE = "SHOW INNODB STATUS ";
    static final String INNODB_FILE_PER_TABLE = "SHOW STATUS LIKE ''";
    static final String STORAGE_TABLESPACE_TOTAL = " SHOW VARIABLES LIKE 'INNODB_DATA_FILE_PATH' ";
    static final String STORAGE_TABLESPACE_FREE = "SHOW TABLE STATUS";
    static final String STORAGE_AUTO_EXTENDS = " SHOW VARIABLES LIKE 'INNODB_DATA_FILE_PATH' ";
    static final String UPTIME = " SHOW STATUS LIKE 'UPTIME' ";
    // 进程
    static final String PROCESSLIST = " SHOW PROCESSLIST ";
    // 日志
    static final String LOGS = " SHOW LOGS ";
    // ERRORS
    static final String ERRORS = " SHOW ERRORS ";
    // STATUS
    public static final String STATUS = " SHOW STATUS ";
    // VARIABLES
    public static final String VARIABLES = " SHOW VARIABLES ";

    // Database
    // public static final String DATABASE =
    // " SELECT * FROM INFORMATION_SCHEMA.SCHEMATA ";
    public static final String DATABASE = " SHOW DATABASES ";
    public static final String DATABASE_STATUS = " SELECT * FROM INFORMATION_SCHEMA.SCHEMATA  ";
    // Tables
    public static final String TABLES = " SHOW TABLES ";
    public static final String TABLES_STATUS = " SHOW TABLE STATUS ";
    // Version
    public static final String VERSION = " SELECT VERSION() ";
    // 属性
    public static final String SERVER_SORT_BUFFER_SIZE = " SHOW VARIABLES LIKE 'SORT_BUFFER_SIZE' ";
    public static final String SERVER_QUERY_CACHE_SIZE = " SHOW VARIABLES LIKE 'QUERY_CACHE_SIZE' ";
    public static final String SERVER_KEY_BLOCKS_USED = " SHOW VARIABLES LIKE 'KEY_BLOCKS_USED' ";
    public static final String SERVER_KEY_CACHE_BLOCK_SIZE = " SHOW VARIABLES LIKE 'KEY_CACHE_BLOCK_SIZE' ";
    public static final String SERVER_KEY_BUFFER_SIZE = " SHOW VARIABLES LIKE 'KEY_BUFFER_SIZE' ";
    public static final String SERVER_QUERY_CACHE_TYPE = " SHOW VARIABLES LIKE 'QUERY_CACHE_TYPE' ";
    public static final String INNODB_BUFFER_POOL_SIZE = " SHOW VARIABLES LIKE 'INNODB_BUFFER_POOL_SIZE' ";
    public static final String INNODB_LOG_BUFFER_SIZE = " SHOW VARIABLES LIKE 'INNODB_LOG_BUFFER_SIZE' ";
    public static final String INNODB_FILE_IO_THREADS = " SHOW VARIABLES LIKE 'INNODB_FILE_IO_THREADS' ";
    public static final String INNODB_LOG_FILE_SIZE = " SHOW VARIABLES LIKE 'INNODB_LOG_FILE_SIZE' ";
    public static final String INNODB_LOG_FILES_IN_GROUP = " SHOW VARIABLES LIKE 'INNODB_LOG_FILES_IN_GROUP' ";
}
